Range Buckets Registry entry
Define range buckets for a field (i.e. when fine-tuning Range Indexing).
Description
Usage
This Registry entry is assigned at the system level only:
Key | System |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Table
|
Key 4 | table |
Key 5 | Range Buckets
|
Key 6 | column |
Value | bucket;bucket;... |
where:
table |
is the name of the EMu module that contains the field to be configured. |
||||||||||||||||||||
column |
is the name of the field (this can be determined by using the What's this help? facility in the EMu client, or via the |
||||||||||||||||||||
bucket;bucket;... |
is a semicolon separated list of values to be used for range buckets. The format of the value depends on the field type. It is important to make sure that the values specified are all fully qualified. In particular, full date values are required. The table below shows what constitutes a fully qualified value for each field type: |
||||||||||||||||||||
|
Examples
In this example the Date Visited field has range buckets of 2000-01-01, 2003-01-01, 2006-01-01 and 2009-01-01. This entry may be used to set these buckets:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Table
|
Key 4 | ecollectionevents
|
Key 5 | Range Buckets
|
Key 6 | ColDateVisited
|
Value | 2000-01-01;2003-01-02;2006-01-01;2009-01-01
|
This Registry entry could be used to set the range buckets on the Latitude field in the Collection Events module:
Key | Setting |
---|---|
Key 1 | System
|
Key 2 | Setting
|
Key 3 | Table
|
Key 4 | ecollectionevents
|
Key 5 | Range Buckets
|
Key 6 | LatLatitude_tab
|
Value | 16:00:00:S;18:00:00:S;20:00:00:S;22:00:00:S
|